use [Yacht Rental]
if OBJECT_ID (N'dbo.lookupdata',N'U') is null
begin 
CREATE TABLE [dbo].[Lookupdata](
	[Lookupdataid] [int] IDENTITY(1,1) NOT NULL,
	[lookupvalue] [varchar](200) NOT NULL,
	[lookupdefinitionid] [int] NOT NULL,
    [createddate][datetime],
	[updatedatetime][datetime],
	[rowstatus] bit)
end
else
begin
alter table [dbo].[Lookupdata] add [shortcode] [varchar](50) not null
print 'inside '
end